package com.ahorresas.modelo.sqls;

public class PerfilSql {
    
    String sql = "";
    
    public String buscarPerfil(){
        sql = "SELECT codigo, nombre "
            + "FROM PERFILES "
            + "WHERE codigo = ?";
        return sql;
    }
    
    public String listarPerfiles(){
        sql = "SELECT codigo, nombre "
            + "FROM PERFILES;";
        return sql;
    }
    
    public String crearPerfil(){
        sql = "INSERT INTO PERFILES (nombre) "
            + "VALUES (?);";
        return sql;
    }
    
    public String modificarPerfil(){
        sql = "UPDATE PERFILES SET nombre = ?  "
            + "WHERE codigo = ?;";
        return sql;
    }
    
    public String eliminarPerfil(){
        sql = "DELETE FROM PERFILES "
            + "WHERE codigo = ?;";
        return sql;
    }
    
}